﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Eliminar.aspx.vb" Inherits="Libreria.Formulario_web19" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" 
    CellPadding="3" DataKeyNames="title_id" DataSourceID="SqlDataSource1" 
    GridLines="Horizontal">
    <AlternatingRowStyle BackColor="#F7F7F7" />
    <Columns>
        <asp:CommandField ShowDeleteButton="True" />
        <asp:BoundField DataField="title_id" HeaderText="title_id" ReadOnly="True" 
            SortExpression="title_id" />
        <asp:BoundField DataField="title" HeaderText="title" SortExpression="title" />
        <asp:BoundField DataField="type" HeaderText="type" SortExpression="type" />
        <asp:BoundField DataField="pub_id" HeaderText="pub_id" 
            SortExpression="pub_id" />
        <asp:BoundField DataField="price" HeaderText="price" SortExpression="price" />
        <asp:BoundField DataField="advance" HeaderText="advance" 
            SortExpression="advance" />
        <asp:BoundField DataField="royalty" HeaderText="royalty" 
            SortExpression="royalty" />
        <asp:BoundField DataField="ytd_sales" HeaderText="ytd_sales" 
            SortExpression="ytd_sales" />
        <asp:BoundField DataField="notes" HeaderText="notes" SortExpression="notes" />
        <asp:BoundField DataField="pubdate" HeaderText="pubdate" 
            SortExpression="pubdate" />
    </Columns>
    <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
    <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
    <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
    <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
    <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
    <SortedAscendingCellStyle BackColor="#F4F4FD" />
    <SortedAscendingHeaderStyle BackColor="#5A4C9D" />
    <SortedDescendingCellStyle BackColor="#D8D8F0" />
    <SortedDescendingHeaderStyle BackColor="#3E3277" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConflictDetection="CompareAllValues" 
    ConnectionString="<%$ ConnectionStrings:pubsConnectionString10 %>" 
    DeleteCommand="DELETE FROM [titles] WHERE [title_id] = @original_title_id AND [title] = @original_title AND [type] = @original_type AND (([pub_id] = @original_pub_id) OR ([pub_id] IS NULL AND @original_pub_id IS NULL)) AND (([price] = @original_price) OR ([price] IS NULL AND @original_price IS NULL)) AND (([advance] = @original_advance) OR ([advance] IS NULL AND @original_advance IS NULL)) AND (([royalty] = @original_royalty) OR ([royalty] IS NULL AND @original_royalty IS NULL)) AND (([ytd_sales] = @original_ytd_sales) OR ([ytd_sales] IS NULL AND @original_ytd_sales IS NULL)) AND (([notes] = @original_notes) OR ([notes] IS NULL AND @original_notes IS NULL)) AND [pubdate] = @original_pubdate" 
    InsertCommand="INSERT INTO [titles] ([title_id], [title], [type], [pub_id], [price], [advance], [royalty], [ytd_sales], [notes], [pubdate]) VALUES (@title_id, @title, @type, @pub_id, @price, @advance, @royalty, @ytd_sales, @notes, @pubdate)" 
    OldValuesParameterFormatString="original_{0}" 
    SelectCommand="SELECT * FROM [titles]" 
    UpdateCommand="UPDATE [titles] SET [title] = @title, [type] = @type, [pub_id] = @pub_id, [price] = @price, [advance] = @advance, [royalty] = @royalty, [ytd_sales] = @ytd_sales, [notes] = @notes, [pubdate] = @pubdate WHERE [title_id] = @original_title_id AND [title] = @original_title AND [type] = @original_type AND (([pub_id] = @original_pub_id) OR ([pub_id] IS NULL AND @original_pub_id IS NULL)) AND (([price] = @original_price) OR ([price] IS NULL AND @original_price IS NULL)) AND (([advance] = @original_advance) OR ([advance] IS NULL AND @original_advance IS NULL)) AND (([royalty] = @original_royalty) OR ([royalty] IS NULL AND @original_royalty IS NULL)) AND (([ytd_sales] = @original_ytd_sales) OR ([ytd_sales] IS NULL AND @original_ytd_sales IS NULL)) AND (([notes] = @original_notes) OR ([notes] IS NULL AND @original_notes IS NULL)) AND [pubdate] = @original_pubdate">
    <DeleteParameters>
        <asp:Parameter Name="original_title_id" Type="String" />
        <asp:Parameter Name="original_title" Type="String" />
        <asp:Parameter Name="original_type" Type="String" />
        <asp:Parameter Name="original_pub_id" Type="String" />
        <asp:Parameter Name="original_price" Type="Decimal" />
        <asp:Parameter Name="original_advance" Type="Decimal" />
        <asp:Parameter Name="original_royalty" Type="Int32" />
        <asp:Parameter Name="original_ytd_sales" Type="Int32" />
        <asp:Parameter Name="original_notes" Type="String" />
        <asp:Parameter Name="original_pubdate" Type="DateTime" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="title_id" Type="String" />
        <asp:Parameter Name="title" Type="String" />
        <asp:Parameter Name="type" Type="String" />
        <asp:Parameter Name="pub_id" Type="String" />
        <asp:Parameter Name="price" Type="Decimal" />
        <asp:Parameter Name="advance" Type="Decimal" />
        <asp:Parameter Name="royalty" Type="Int32" />
        <asp:Parameter Name="ytd_sales" Type="Int32" />
        <asp:Parameter Name="notes" Type="String" />
        <asp:Parameter Name="pubdate" Type="DateTime" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="title" Type="String" />
        <asp:Parameter Name="type" Type="String" />
        <asp:Parameter Name="pub_id" Type="String" />
        <asp:Parameter Name="price" Type="Decimal" />
        <asp:Parameter Name="advance" Type="Decimal" />
        <asp:Parameter Name="royalty" Type="Int32" />
        <asp:Parameter Name="ytd_sales" Type="Int32" />
        <asp:Parameter Name="notes" Type="String" />
        <asp:Parameter Name="pubdate" Type="DateTime" />
        <asp:Parameter Name="original_title_id" Type="String" />
        <asp:Parameter Name="original_title" Type="String" />
        <asp:Parameter Name="original_type" Type="String" />
        <asp:Parameter Name="original_pub_id" Type="String" />
        <asp:Parameter Name="original_price" Type="Decimal" />
        <asp:Parameter Name="original_advance" Type="Decimal" />
        <asp:Parameter Name="original_royalty" Type="Int32" />
        <asp:Parameter Name="original_ytd_sales" Type="Int32" />
        <asp:Parameter Name="original_notes" Type="String" />
        <asp:Parameter Name="original_pubdate" Type="DateTime" />
    </UpdateParameters>
</asp:SqlDataSource>
<br />
</asp:Content>
